-
Re: Need to remove characters from a text string that appear after >
=LEFT(Text@row, FIND(">", Text@row, 1) - 1)2 · -
Re: Share Data Shuttle Workflows
100% upvote, the only other data shuttle user in my company left this year. Took hours for him to detail his workflows for me, and hours more of me to recreate them. Painfully inefficaiant.7 · -
Re: Delete Rows using an Automation
@Jake Gustafson My only suggestion would be to add yet another sheet beyond your archive sheet. Use a date based move row to from you archive to the new garbage sheet. Now anyone can just delete all …2 · -
Re: Delete Rows using an Automation
@Ian Cooper @Jake Gustafson I agree this would be a great feature. One workaround when move row is to use a Data Shuttle replace all with a blank excel to clear the archive sheet on a set schedule.2 · -
Re: Replacing sheet data regularly to update dashboard
@Geraldine Ahsue Any formulas in the sheet summary and any additional columns that use column formulas will persist when the data is replaced or merged. I have many Datashuttle workflows running on d…1 ·